Performance Analysis of Optimization Techniques for SQL Multi Query Expressions Over Text Databases in RDBMS

This paper begins by introducing the concept of Optimization in SQL Queries. The introductory section gives brief information on the strategies, an optimizer should follow. In order to examine the role of query optimization process in RDBMS, this paper will look at both static and dynamic process of optimization as well as all the general aspects of query optimization. The paper will then explore major principles of query optimization process with volcano query optimization. An enhancement to volcano query optimizer is proposed by adding some set of transformation rules and operators. The search space principle will elaborate various types of query tree. The search strategy principle will elaborate various search strategy techniques including dynamic and greedy algorithms that will play a big role in improving the overall efficiency of relational database systems. Finally, this paper ends with the conclusion of highlighted issues and solutions.